Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?

Поиск
Список
Период
Сортировка
От Herouth Maoz
Тема Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?
Дата
Msg-id l03130302b3bb46f98fd9@[147.233.159.109]
обсуждение исходный текст
Ответ на Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?  (Chris Bitmead <chris@tech.com.au>)
Список pgsql-sql
Дерево обсуждения 
At 12:36 +0300 on 21/07/1999, Chris Bitmead wrote:


> I missed the original question, but don't you get sequential numbers as
> long as cache is 0?

No. If an insert failed or a transaction failed, the sequence remains in
its new state.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

В списке pgsql-sql по дате отправления:

Предыдущее
От: Chris Bitmead
Дата:
Сообщение: Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?
Следующее
От: "Jonathan davis"
Дата:
Сообщение: pb with pg_group